##############################################################################
# Python From Scratch
# Autor: Nilo Ney Coutinho Menezes
# Editora Novatec (c) 2010-2024
# Site: https://pythonfromscratch.com
#
# File: listing\chapter 11\11.1498 - No Title.py
# Description: No Title
##############################################################################

select region, count(*), min(population),
           max(population), avg(population), sum(population) as tpop
           from states group by region
       having count(*) > 5
           order by tpop desc